﻿CREATE TABLE [dbo].[FunctionalGroup]
(
[FunctionalIdentifierCode] [nvarchar] (2) NULL,
[ApplicationSenderCode] [nvarchar] (15) NULL,
[ApplicationReceiverCode] [nvarchar] (15) NULL,
[GroupDate] [nvarchar] (20) NULL,
[GroupTime] [nvarchar] (20) NULL,
[GroupControlNumber] [nvarchar] (9) NULL,
[ResponsibleAgencyCode] [nvarchar] (2) NULL,
[VersionReleaseIndustryIdentifierCode] [nvarchar] (12) NULL,
[NumberofTransactionSetsIncluded] [int] NULL,
[EDIMessageType] [nvarchar] (50) NULL,
[InterchangeControlNumber] [nvarchar] (9) NULL,
[InterchangeIDKey] [int] NULL,
[GroupIDKey] [int] NOT NULL IDENTITY(1, 1),
[BTSMessageID] [nvarchar] (100) NULL,
[BTSInterchangeID] [nvarchar] (100) NULL
) ON [PRIMARY]


